The dashboard is to examine hotel cancellations and factors associated with hotel cancellations in the United States between 2015 and 2017.
The dataset is included in TidyTuesday, 2020-02-11. The original dataset comes from an open hotel booking demand dataset from Antonio, Almeida and Nunes, 2019. This dataset includes bookings of resort hotels or city hotels between the 1st of July of 2015 and the 31st of August 2017, including bookings that effectively arrived and bookings that were canceled.
| Overall (N=2097) |
No (N=1596) |
Yes (N=501) |
|
|---|---|---|---|
| Type of hotel | |||
| City Hotel | 1618 (77.2%) | 1189 (74.5%) | 429 (85.6%) |
| Resort Hotel | 479 (22.8%) | 407 (25.5%) | 72 (14.4%) |
| Number of days between booking and arrival | |||
| Mean (SD) | 77.2 (82.7) | 70.7 (82.6) | 97.8 (79.8) |
| Median [Min, Max] | 51.0 [0, 542] | 40.0 [0, 542] | 77.0 [0, 327] |
| Year of arrival date | |||
| 2015 | 180 (8.6%) | 180 (11.3%) | 0 (0%) |
| 2016 | 963 (45.9%) | 748 (46.9%) | 215 (42.9%) |
| 2017 | 954 (45.5%) | 668 (41.9%) | 286 (57.1%) |
| Season of arrival date | |||
| Spring | 589 (28.1%) | 426 (26.7%) | 163 (32.5%) |
| Summer | 851 (40.6%) | 616 (38.6%) | 235 (46.9%) |
| Fall | 412 (19.6%) | 354 (22.2%) | 58 (11.6%) |
| Winter | 245 (11.7%) | 200 (12.5%) | 45 (9.0%) |
| Number of weekend nights stayed | |||
| Mean (SD) | 0.855 (0.929) | 0.812 (0.921) | 0.992 (0.942) |
| Median [Min, Max] | 1.00 [0, 13.0] | 1.00 [0, 13.0] | 1.00 [0, 5.00] |
| Number of week nights stayed | |||
| Mean (SD) | 1.92 (1.67) | 1.83 (1.64) | 2.21 (1.73) |
| Median [Min, Max] | 2.00 [0, 30.0] | 1.00 [0, 30.0] | 2.00 [0, 11.0] |
| Number of adults | |||
| Mean (SD) | 1.88 (0.526) | 1.86 (0.521) | 1.95 (0.535) |
| Median [Min, Max] | 2.00 [0, 4.00] | 2.00 [0, 4.00] | 2.00 [0, 3.00] |
| Number of children and babies | |||
| Mean (SD) | 0.175 (0.534) | 0.150 (0.492) | 0.255 (0.644) |
| Median [Min, Max] | 0 [0, 3.00] | 0 [0, 3.00] | 0 [0, 2.00] |
| Repeated guest | |||
| No | 2078 (99.1%) | 1578 (98.9%) | 500 (99.8%) |
| Yes | 19 (0.9%) | 18 (1.1%) | 1 (0.2%) |
| Number of changes to the booking | |||
| Mean (SD) | 0.339 (0.866) | 0.367 (0.922) | 0.250 (0.654) |
| Median [Min, Max] | 0 [0, 14.0] | 0 [0, 14.0] | 0 [0, 5.00] |
| Average daily rate, $ | |||
| Mean (SD) | 123 (51.6) | 119 (51.4) | 136 (50.1) |
| Median [Min, Max] | 115 [0, 328] | 109 [0, 328] | 128 [0, 311] |